
CREATE TABLE [dbo].[KONSTRUKCIOK](
	[KNS_ID] [int] IDENTITY(1,1) NOT NULL,
	[KNS_NEV] [varchar](50) COLLATE SQL_Hungarian_CP1250_CS_AS NOT NULL CONSTRAINT [DF_KONSTRUKCIOK_KNS_NEV]  DEFAULT (''),
	[KNS_KIZART] [varchar](1) COLLATE SQL_Hungarian_CP1250_CS_AS NOT NULL CONSTRAINT [DF_KONSTRUKCIOK_KNS_KIZART]  DEFAULT ('N'),
 CONSTRAINT [PK_KONSTRUKCIOK] PRIMARY KEY CLUSTERED 
(
	[KNS_ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
